﻿CREATE TABLE [flcr].[SUPPORT_ROLE_TYPE] (
    [SUPPORT_ROLE_TYPE_ID]    INT           IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]              VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]              DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]           INT           NOT NULL,
    [AUDIT_MOD_USER]          VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]          DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]       INT           NOT NULL,
    [BUILTIN]                 BIT           NOT NULL,
    [ACTIVE_FLG]              BIT           NOT NULL,
    [SORT_ORDER]              INT           NOT NULL,
    [SUPPORT_ROLE_TYPE]       INT           NOT NULL,
    [SUPPORT_ROLE_TYPE_NAME]  VARCHAR (100) NOT NULL,
    [SUPPORT_ROLE_TYPE_DESC]  VARCHAR (250) NOT NULL,
    [SUPPORT_ROLE_TYPE_GROUP] INT           NOT NULL,
    [PARENT_ID]               INT           NULL
);

